<?php

use think\migration\Migrator;
use think\migration\db\Column;

class Profile extends Migrator
{
	/**
	 * Change Method.
	 *
	 * Write your reversible migrations using this method.
	 *
	 * More information on writing migrations is available here:
	 * http://docs.phinx.org/en/latest/migrations.html#the-abstractmigration-class
	 *
	 * The following commands can be used in this method and Phinx will
	 * automatically reverse them when rolling back:
	 *
	 *    createTable
	 *    renameTable
	 *    addColumn
	 *    renameColumn
	 *    addIndex
	 *    addForeignKey
	 *
	 * Remember to call "create()" or "update()" and NOT "save()" when working
	 * with the Table class.
	 */
	public function change()
	{
		$table = $this->table('profile', [ 'engine' => 'MyISAM' ]);
		$table->addColumn('user_id', 'integer', [ 'limit' => 11, 'default' => 0, 'comment' => '用户id' ])
			->addColumn('nickname', 'string', [ 'limit' => 20, 'default' => '', 'comment' => '用户昵称' ])
			->addColumn('gender', 'integer', [ 'limit' => 3, 'default' => 0, 'comment' => '性别 0未知 1男 2女' ])
			->addColumn('head_img', 'string', [ 'limit' => 100, 'default' => '', 'comment' => '用户头像' ])
			->addColumn('create_time', 'integer', [ 'default' => 0, 'comment' => '' ])
			->addColumn('update_time', 'integer', [ 'default' => 0, 'comment' => '' ])
			->addIndex([ 'user_id' ], [ 'unique' => true ])
			->create();
	}
}
